|
JCapper Message Board JCapper 101
|
| Home |
Register
Log In |
| By | SQL question | |
| NYMike 4/24/2022 2:36:44 AM | Is there a way to write a udm that identifies a horse whose average finish position for the last three races is less than its average rankodds for those three races, and have it fire during a calc race? To be clear, I am not looking for it to fire based on todays race's odds, I just want it to evaluate it based on the last few races. Thanks, Mike
| |
| jeff 4/30/2022 12:44:27 PM | There isn't a way to flag that because odds for past running lines isn't part of the factor set. That said, I'm thinking you may find some of the TDx NCall factors useful once added to your SQL Factor Setup. FYI, I'm currently using these: 01. NCALL_TDX_START_BEST10 02. NCALL_TDX_START_CX10 03. NCALL_TDX_PACE_BEST10 04. NCALL_TDX_PACE_CX10 05. NCALL_TDX_FIN_BEST10 06. NCALL_TDX_FIN_CX10 If I can find some free time, I plan on creating a JCapper2.mdb file with the following TDx NCall factors included in the SQL Factor Setup, building the most recent two or three years, and testing whether or not it makes sense to include these in some of my models: 01. NCALL_TDX_CSFIN_BEST10 02. NCALL_TDX_CSFIN_CX10 03. TDX_BTNLEN_BEST10 04. TDX_BTNLEN_CX10 05. TDX_GIS_BEST10 06. TDX_GIS_CX10 -jp .
| |
| NYMike 4/30/2022 5:24:45 PM | Jeff, If not RankOdds, would it be able to capture RankMLine? I will check out the TDx NCall factors. Thanks, Mike
|
| Reply |
|
Copyright © 2018 JCapper Software back to the JCapper Message Board www.JCapper.com |